/**
 * bclass表操作 
 */
var MenuData = {
    // 获取班级数据
    queryClassData: function() {
        return "select * from bclass";
    },
    // 根据用户ID获取班级数据
    queryClassById: function(params) {
        return "select * from bclass a left join bu b on a.ID = b.bid where b.uid = "+"'"+params.ID+"'";
    },
    // 删除ID对应的数据
    deleteData: function(param) {
        return "DELETE from bclass where ID = " + param.ID;
    },
    // 增加数据
    insertData: function(param) {
        return "INSERT INTO bclass set name = '"+param.name+"'";
    },
    // 更新数据
    updatetData: function(param) {
        return "UPDATE bclass SET name = '"+param.name+"'"+" WHERE ID = '"+param.ID+"'";
    }
}
exports = module.exports = MenuData;